Helpful Information
 
 
Category: Binary
Text file -> binary ->database<binary>

anyone can tell how to convert a 40kb text file, to binary which i wanna store inside sql2000 database in <binary> field.

and how to retrieve it back to text file.

bump.. anyone? pls help me

What do you have so far?

currently i know how to insert into database
just wonder how to convert .txt to binary and call it out

This will read in the file and convert it to a ASCII encoded bytes.

Dim byt() As Byte

byt = System.Text.Encoding.ASCII.GetBytes(System.IO.File.OpenText("C:\SomePath\SomeTextfile.txt").ReadToEnd)

MsgBox(byt.GetLength(0))










privacy (GDPR)